use inspection

alter table inspection_branch
	add is_del int default 0 not null
go

alter table inspection_department
	add is_del int default 0 not null
go

alter table inspection_department
	add parent_id bigint
go

alter table inspection_department
	add is_leaf_node int default 0
go


update dbo.inspection_department set parent_id=-1,is_leaf_node =1





DROP TABLE [dbo].[sys_dept]
DROP TABLE [dbo].[sys_role_dept]
DROP TABLE [dbo].[testuser]





DROP TABLE [dbo].[sys_user]

CREATE TABLE [dbo].[sys_user] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [user_code] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [mobile] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [password] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [real_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [work_phone] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [email] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [salt] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_status] int  NULL,
  [dept_id] bigint  NULL,
  [date_create] datetime  NULL,
  [date_update] datetime  NULL,
  [is_del] int  NULL,
  CONSTRAINT [PK__sys_user__B9BE370F0CDAE408] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY],
  CONSTRAINT [uk_usercode] UNIQUE NONCLUSTERED ([user_code] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY],
  CONSTRAINT [uk_username] UNIQUE NONCLUSTERED ([user_name] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户编号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机号登錄賬號',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'mobile'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'真名',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'real_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工作机号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'work_phone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'邮箱',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'盐',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'salt'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态  -1：禁用   1：正常',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'dept_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'date_create'
GO

EXEC sp_addextendedproperty
'MS_Description', N'0 未删除 1 已删除',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'is_del'





CREATE TABLE [dbo].[sys_config] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [config_code] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [config_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [config_value] varchar(1024) COLLATE Chinese_PRC_CI_AS  NULL,
  [date_create] datetime  NULL,
  [is_del] int DEFAULT ((0)) NOT NULL,
  [remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  CONSTRAINT [sys_config_pk] PRIMARY KEY NONCLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_config] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'配置名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_config',
'COLUMN', N'config_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_config',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统配置',
'SCHEMA', N'dbo',
'TABLE', N'sys_config'


INSERT INTO [dbo].[sys_user]([user_code], [user_name], [mobile], [password], [real_name], [work_phone], [email], [salt], [user_status], [dept_id], [date_create], [date_update], [is_del]) VALUES ( '00000', 'admin', '18888888888', '473d9b7e436095d7fb68663b81bb336a', '超级用户', '123456', 'dddd', NULL, 1, NULL, '2020-12-04 11:13:37.653', NULL, 0);



ALTER TABLE [dbo].[sys_file] ADD [model_name] varchar(255)



DROP TABLE [dbo].[sys_menu]



CREATE TABLE [dbo].[sys_menu] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [parent_id] bigint  NULL,
  [name] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [url] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [perms] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [type] int  NULL,
  [icon] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [order_num] int  NULL,
  CONSTRAINT [PK__sys_menu__4CA0FADC7BB05806] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'父菜单ID，一级菜单为0',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单URL',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'授权(多个用逗号分隔，如：user:list,user:create)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'perms'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型   0：目录   1：菜单   2：按钮',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单图标',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'icon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'order_num'




DROP TABLE [dbo].[sys_role]


CREATE TABLE [dbo].[sys_role] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [role_name] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime  NULL,
  CONSTRAINT [PK__sys_role__760965CC0169315C] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'role_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'create_time'



DROP TABLE [dbo].[sys_role_menu]


CREATE TABLE [dbo].[sys_role_menu] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [role_id] bigint  NULL,
  [menu_id] bigint  NULL,
  CONSTRAINT [PK__sys_role__3213E83F07220AB2] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_role_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_menu',
'COLUMN', N'role_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_menu',
'COLUMN', N'menu_id'



DROP TABLE [dbo].[sys_user_role]


CREATE TABLE [dbo].[sys_user_role] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [user_id] bigint  NULL,
  [role_id] bigint  NULL,
  CONSTRAINT [PK__sys_user__3213E83F0FB750B3] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_user_role] SET (LOCK_ESCALATION = TABLE)





       CREATE TABLE [dbo].[sys_dict] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [name] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [type] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [code] int  NOT NULL,
  [value] varchar(1000) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [order_num] int  NULL,
  [remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [del_flag] tinyint  NULL,
  CONSTRAINT [PK__sys_dict__3213E83F75F77EB0] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_dict] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典类型',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典码',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典值',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'value'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'order_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标记  -1：已删除  0：正常',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'del_flag'





CREATE TABLE [dbo].[sys_log] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [user_id] bigint  NULL,
  [user_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [operation_code] int  NULL,
  [operation_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [method] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [params] varchar(5000) COLLATE Chinese_PRC_CI_AS  NULL,
  [cost_time] bigint  NULL,
  [source_ip] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [date_create] datetime  NULL,
  CONSTRAINT [sys_log_pk] PRIMARY KEY NONCLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'cost_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'访问源头ip',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'source_ip'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统操作日志',
'SCHEMA', N'dbo',
'TABLE', N'sys_log'



SET IDENTITY_INSERT [dbo].[sys_menu] ON


INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (547, -1, '系统管理', '/system', NULL, 0, 'desktop', 4);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (548, 547, '菜单管理', '/system/menu', 'system:menu', 1, NULL, 2);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (549, 547, '参数管理', '/system/config', 'system:config', 1, NULL, 1);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (550, 549, '查看', NULL, 'system:config:list', 2, NULL, 1);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (551, 549, '新增', NULL, 'system:config:save', 2, NULL, 2);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (552, -1, '基础设置', '/basic', NULL, 0, 'setting', 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (553, 552, '部门管理', '/basic/dept', 'basic:dept', 1, NULL, 1);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (554, 549, '修改', NULL, 'system:config:update', 2, NULL, 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (555, 549, '删除', NULL, 'system:config:del', 2, NULL, 4);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (556, -1, '预警分析', '/dashboard', NULL, 0, 'dashboard', 1);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (557, 556, '生态指数', '/dashboard/ecology', 'dashboard:ecology', 1, NULL, 1);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (558, 556, '考核占比', '/dashboard/ratio', 'dashboard:ratio', 1, NULL, 2);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (559, 556, '整改落实', '/dashboard/rectification', 'dashboard:rectification', 1, NULL, 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (560, 556, '考核排名', '/dashboard/warning', 'dashboard:warning', 1, NULL, 4);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (561, -1, '量化评估', '/inspection', NULL, 0, 'table', 2);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (562, 561, '考核基础', '/inspection/base', 'inspection:base', 1, NULL, 1);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (563, 561, '支部列表', '/inspection/branch', 'inspection:branch', 1, NULL, 2);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (564, 561, '考核指标体系', '/inspection/regulation', 'inspection:regulation', 1, NULL, 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (565, 561, '数据采集', '/inspection/event', 'inspection:event', 1, NULL, 4);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (566, 561, '汇总测算', '/inspection/summary', 'inspection:summary', 1, NULL, 5);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (567, 561, '预警发布', '/inspection/violations', 'inspection:violations', 1, NULL, 6);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (568, 561, '综合排名', '/inspection/political', 'inspection:political', 1, NULL, 7);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (569, 552, '人员管理', '/basic/user', 'basic:user', 1, NULL, 2);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (570, 552, '角色管理', '/basic/role', 'basic:role', 1, NULL, 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (574, 547, '云文件', '/system/cloudFile', 'system:cloudFile', 1, NULL, 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (575, 552, '字典管理', '/basic/dict', 'basic:dict', 1, NULL, 3);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (577, 548, '查看', NULL, '111', 2, NULL, 10);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (578, 549, '批量删除', NULL, 'system:config:batchDel', 2, NULL, 5);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (10576, 553, '查询', NULL, 'basic:dept:list', 2, NULL, NULL);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (10577, 553, '新增', NULL, 'basic:dept:add', 2, NULL, NULL);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (10578, 553, '编辑', NULL, 'basic:dept:update', 2, NULL, NULL);
INSERT INTO [dbo].[sys_menu]([id], [parent_id], [name], [url], [perms], [type], [icon], [order_num]) VALUES (10579, 553, '删除', NULL, 'basic:dept:del', 2, NULL, NULL);

SET IDENTITY_INSERT [dbo].[sys_menu] OFF



SET IDENTITY_INSERT [dbo].[sys_role_menu] ON

INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10253, 7, 547);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10254, 7, 548);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10255, 7, 549);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10256, 7, 550);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10257, 7, 551);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10258, 7, 552);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10259, 7, 553);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10260, 7, 554);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10261, 7, 555);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10262, 7, 556);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10263, 7, 557);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10264, 7, 558);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10265, 7, 559);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10266, 7, 560);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10267, 7, 561);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10268, 7, 562);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10269, 7, 563);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10270, 7, 564);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10271, 7, 565);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10272, 7, 566);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10273, 7, 567);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10274, 7, 568);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10275, 7, 569);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10276, 7, 570);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10277, 7, 574);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10278, 7, 575);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10279, 7, 578);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10280, 7, 10579);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10281, 7, 10578);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10282, 7, 10577);
INSERT INTO [dbo].[sys_role_menu]([id], [role_id], [menu_id]) VALUES (10283, 7, 10576);

SET IDENTITY_INSERT [dbo].[sys_role_menu] OFF



SET IDENTITY_INSERT [dbo].[sys_role] ON


INSERT INTO [dbo].[sys_role]([id], [role_name], [remark], [create_time]) VALUES (7, '管理员', '123', '2020-12-14 18:08:06.676');

SET IDENTITY_INSERT [dbo].[sys_role] OFF







SET IDENTITY_INSERT [dbo].[sys_user_role] ON



INSERT INTO [dbo].[sys_user_role]([id], [user_id], [role_id]) VALUES (1, 1, 7);



SET IDENTITY_INSERT [dbo].[sys_user_role] OFF


